Tabela PhDeliveryItemPrep

Definicja tabeli PhDeliveryItemPrep

Name

PhDeliveryItemPrep

Code

PhDeliveryItemPrep

Comment

Przygotowania do podania leków pacjentowi


Lista kolumn tabeli PhDeliveryItemPrep

Name

Code

DeliveryItemPrepId

DeliveryItemPrepId

StOrderItemID

StOrderItemID

LotInStID

LotInStID

PresentationUnitID

PresentationUnitID

Quantity

Quantity

Realized

Realized


Kolumna DeliveryItemPrepId tabeli PhDeliveryItemPrep

Definicja kolumny DeliveryItemPrepId tabeli PhDeliveryItemPrep

Name

DeliveryItemPrepId

Code

DeliveryItemPrepId

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderItemID tabeli PhDeliveryItemPrep

Definicja kolumny StOrderItemID tabeli PhDeliveryItemPrep

Name

StOrderItemID

Code

StOrderItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LotInStID tabeli PhDeliveryItemPrep

Definicja kolumny LotInStID tabeli PhDeliveryItemPrep

Name

LotInStID

Code

LotInStID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PresentationUnitID tabeli PhDeliveryItemPrep

Definicja kolumny PresentationUnitID tabeli PhDeliveryItemPrep

Name

PresentationUnitID

Code

PresentationUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Wyswietlana jednostka podawcza


Kolumna Quantity tabeli PhDeliveryItemPrep

Definicja kolumny Quantity tabeli PhDeliveryItemPrep

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

Yes

Comment

Ilosc do podania


Kolumna Realized tabeli PhDeliveryItemPrep

Definicja kolumny Realized tabeli PhDeliveryItemPrep

Name

Realized

Code

Realized

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Flaga trzymajaca informacje na temat zrealizowania (podania) danego leku


Lista kluczy tabeli PhDeliveryItemPrep

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhDeliveryItemPrep

Definicja klucza Identifier_1 tabeli PhDeliveryItemPrep

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment